package com.neusoft.tijiancms.mapper;

import com.neusoft.tijiancms.po.Setmeal;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SetmealMapper {
    /**
     * 根据Id查询信息
     * @param smId
     * @return
     */
    //@Select("SELECT * FROM setmeal WHERE smId=#{smId}")
    public Setmeal getSetmealById(Integer smId);

    /**
     * 多表连接查询明细数据
     * @param setmeal
     * @return
     */
  //  public List<Setmeal>getSetmealData(Setmeal setmeal);

    /**
     * 查询体检项列表
     * @return
     */
    @Select("SELECT * FROM setmeal order by smId")
    public List<Setmeal>listSetmeal();

    //为OrdersMapper中的listOrders方法做关联查询用的
    @Select("SELECT * FROM setmeal WHERE smId=#{smId}")
    public Setmeal getSetmealByIdByMapper(Integer smId);

}
